
IF NOT EXISTS(SELECT * FROM dbo.HC_ENV WHERE ENV_CD='ITG')
BEGIN
INSERT INTO dbo.HC_ENV (ENV_CD,ENV_NM)VALUES('ITG','ITG')
END
IF NOT EXISTS(SELECT * FROM dbo.HC_ENV WHERE ENV_CD='UAT')
BEGIN
INSERT INTO dbo.HC_ENV (ENV_CD,ENV_NM)VALUES('UAT','UAT')
END
IF NOT EXISTS(SELECT * FROM dbo.HC_ENV WHERE ENV_CD='PRO')
BEGIN
INSERT INTO dbo.HC_ENV (ENV_CD,ENV_NM)VALUES('PRO','Production')
END